{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Gradient","Flow Rate"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,0,34,0],[36,2,36,31]]}
["Finite Difference Solution - 2D Seepage"]
["CE En 544 - Brigham Young University"]
[]
[null,null,"Head 1:",null,null,null,"Head 1:",80,{"$f":"\"[\" & lunit & \"]\"","v":"[ft]"},null,null,"Length unit:","ft"]
[null,null,"Head 2:",null,null,null,"Head 2:",60,{"$f":"\"[\" & lunit & \"]\"","v":"[ft]"},null,null,"Time unit:","day",null,null,null,"Arrow size:",20]
[null,null,"Active:",null,null,null,"Cell Size:",10,{"$f":"\"[\" & lunit & \"]\"","v":"[ft]"},null,null,null,null,null,null,null,"Arrow color:"]
[null,null,"Background:"]
[]
[]
["Y",{"$f":"B11+cellsize","v":250}]
[null,240]
[null,230]
[null,220]
[null,210]
[null,200]
[null,190]
[null,180]
[null,170,null,null,null,null,{"$f":"H_1","v":80},{"$f":"H_1","v":80},{"$f":"H_1","v":80},{"$f":"H_1","v":80},{"$f":"H_1","v":80},{"$f":"H_1","v":80},{"$f":"H_1","v":80},{"$f":"H_1","v":80},{"$f":"(O19 + 0.5*N18 + 0.5*P18)/2","v":75.809176748322869},{"$f":"(P19 + 0.5*O18 + 0.5*Q18)/2","v":73.166337176302036},{"$f":"(Q19 + 0.5*P18 + 0.5*R18)/2","v":71.015078071358531},{"$f":"(R19 + 0.5*Q18 + 0.5*S18)/2","v":68.984063879114814},{"$f":"(S19 + 0.5*R18 + 0.5*T18)/2","v":66.832903314908549},{"$f":"(T19 + 0.5*S18 + 0.5*U18)/2","v":64.19029998954997},{"$f":"H_2","v":60},{"$f":"H_2","v":60},{"$f":"H_2","v":60},{"$f":"H_2","v":60},{"$f":"H_2","v":60},{"$f":"H_2","v":60},{"$f":"H_2","v":60},{"$f":"H_2","v":60}]
[null,160,null,null,null,null,{"$f":"(0.5*G18 + 0.5*G20 + H19)/2","v":79.12330812310914},{"$f":"(H18 + H20 + G19 + I19)/4","v":79.107728206594999},{"$f":"(I18 + I20 + H19 + J19)/4","v":79.058661097786924},{"$f":"(J18 + J20 + I19 + K19)/4","v":78.968035279974345},{"$f":"(K18 + K20 + J19 + L19)/4","v":78.817752379464991},{"$f":"(L18 + L20 + K19 + M19)/4","v":78.56777245602764},{"$f":"(M18 + M20 + L19 + N19)/4","v":78.121591339756435},{"$f":"(N18 + N20 + M19 + O19)/4","v":77.21617749274472},{"$f":"(O18 + O20 + N19 + P19)/4","v":75.035189576303651},{"$f":"(P18 + P20 + O19 + Q19)/4","v":72.920552521391244},{"$f":"(Q18 + Q20 + P19 + R19)/4","v":70.954961515840353},{"$f":"(R18 + R20 + Q19 + S19)/4","v":69.044142721972236},{"$f":"(S18 + S20 + R19 + T19)/4","v":67.078629463570294},{"$f":"(T18 + T20 + S19 + U19)/4","v":64.9641512230519},{"$f":"(U18 + U20 + T19 + V19)/4","v":62.783384817444301},{"$f":"(V18 + V20 + U19 + W19)/4","v":61.878055625034563},{"$f":"(W18 + W20 + V19 + X19)/4","v":61.431912514168744},{"$f":"(X18 + X20 + W19 + Y19)/4","v":61.181952108122815},{"$f":"(Y18 + Y20 + X19 + Z19)/4","v":61.031680137655961},{"$f":"(Z18 + Z20 + Y19 + AA19)/4","v":60.941060571301456},{"$f":"(AA18 + AA20 + Z19 + AB19)/4","v":60.89199671760732},{"$f":"(0.5*AB18 + 0.5*AB20 + AA19)/2","v":60.876417780856983}]
[null,150,null,null,null,null,{"$f":"(0.5*G19 + 0.5*G21 + H20)/2","v":78.277781140728678},{"$f":"(H19 + H21 + G20 + I20)/4","v":78.248947398222583},{"$f":"(I19 + I21 + H20 + J20)/4","v":78.158884736288144},{"$f":"(J19 + J21 + I20 + K20)/4","v":77.995731557064914},{"$f":"(K19 + K21 + J20 + L20)/4","v":77.735205849409866},{"$f":"(L19 + L21 + K20 + M20)/4","v":77.331750458094291},{"$f":"(M19 + M21 + L20 + N20)/4","v":76.702420340417717},{"$f":"(N19 + N21 + M20 + O20)/4","v":75.707935309599918},{"$f":"(O19 + O21 + N20 + P20)/4","v":74.194859008993063},{"$f":"(P19 + P21 + O20 + Q20)/4","v":72.52573003450533},{"$f":"(Q19 + Q21 + P20 + R20)/4","v":70.840081163819463},{"$f":"(R19 + R21 + Q20 + S20)/4","v":69.158924063532083},{"$f":"(S19 + S21 + R20 + T20)/4","v":67.473327661792425},{"$f":"(T19 + T21 + S20 + U20)/4","v":65.804296257472529},{"$f":"(U19 + U21 + T20 + V20)/4","v":64.291337149474288},{"$f":"(V19 + V21 + U20 + W20)/4","v":63.29692937299702},{"$f":"(W19 + W21 + V20 + X20)/4","v":62.667646220663045},{"$f":"(X19 + X21 + W20 + Y20)/4","v":62.264219489186594},{"$f":"(Y19 + Y21 + X20 + Z20)/4","v":62.003711459949145},{"$f":"(Z19 + Z21 + Y20 + AA20)/4","v":61.840568942696699},{"$f":"(AA19 + AA21 + Z20 + AB20)/4","v":61.750511986370483},{"$f":"(0.5*AB19 + 0.5*AB21 + AA20)/2","v":61.721679975121006}]
[null,140,null,null,null,null,{"$f":"(0.5*G20 + 0.5*G22 + H21)/2","v":77.489930329073346},{"$f":"(H20 + H22 + G21 + I21)/4","v":77.451401697846762},{"$f":"(I20 + I22 + H21 + J21)/4","v":77.332205135936348},{"$f":"(J20 + J22 + I21 + K21)/4","v":77.120806719545001},{"$f":"(K20 + K22 + J21 + L21)/4","v":76.795595555417094},{"$f":"(L20 + L22 + K21 + M21)/4","v":76.321610060289615},{"$f":"(M20 + M22 + L21 + N21)/4","v":75.648411642967062},{"$f":"(N20 + N22 + M21 + O21)/4","v":74.718292546643738},{"$f":"(O20 + O22 + N21 + P21)/4","v":73.510589987114543},{"$f":"(P20 + P22 + O21 + Q21)/4","v":72.147436781600575},{"$f":"(Q20 + Q22 + P21 + R21)/4","v":70.720718488891976},{"$f":"(R20 + R22 + Q21 + S21)/4","v":69.278153880210311},{"$f":"(S20 + S22 + R21 + T21)/4","v":67.851469416435606},{"$f":"(T20 + T22 + S21 + U21)/4","v":66.48837673131284},{"$f":"(U20 + U22 + T21 + V21)/4","v":65.280745202792261},{"$f":"(V20 + V22 + U21 + W21)/4","v":64.350685056762501},{"$f":"(W20 + W22 + V21 + X21)/4","v":63.677529725577237},{"$f":"(X20 + X22 + W21 + Y21)/4","v":63.203574153603192},{"$f":"(Y20 + Y22 + X21 + Z21)/4","v":62.878383096337075},{"$f":"(Z20 + Z22 + Y21 + AA21)/4","v":62.666997473409232},{"$f":"(AA20 + AA22 + Z21 + AB21)/4","v":62.54780796653364},{"$f":"(0.5*AB20 + 0.5*AB22 + AA21)/2","v":62.509281491747942}]
[null,130,null,null,null,null,{"$f":"(0.5*G21 + 0.5*G23 + H22)/2","v":76.779148846688415},{"$f":"(H21 + H23 + G22 + I22)/4","v":76.734532337026849},{"$f":"(I21 + I23 + H22 + J22)/4","v":76.597735856315524},{"$f":"(J21 + J23 + I22 + K22)/4","v":76.35970321219186},{"$f":"(K21 + K23 + J22 + L22)/4","v":76.004768364484306},{"$f":"(L21 + L23 + K22 + M22)/4","v":75.510691639030654},{"$f":"(M21 + M23 + L22 + N22)/4","v":74.851333068557778},{"$f":"(N21 + N23 + M22 + O22)/4","v":74.006243166247458},{"$f":"(O21 + O23 + N22 + P22)/4","v":72.981781967698993},{"$f":"(P21 + P23 + O22 + Q22)/4","v":71.832719251822652},{"$f":"(Q21 + Q23 + P22 + R22)/4","v":70.617212816492213},{"$f":"(R21 + R23 + Q22 + S22)/4","v":69.38151404163078},{"$f":"(S21 + S23 + R22 + T22)/4","v":68.166029472354353},{"$f":"(T21 + T23 + S22 + U22)/4","v":67.017005601224952},{"$f":"(U21 + U23 + T22 + V22)/4","v":65.992590922443839},{"$f":"(V21 + V23 + U22 + W22)/4","v":65.147544556721783},{"$f":"(W21 + W23 + V22 + X22)/4","v":64.48822177848028},{"$f":"(X21 + X23 + W22 + Y22)/4","v":63.994172368153158},{"$f":"(Y21 + Y23 + X22 + Z22)/4","v":63.639257186982782},{"$f":"(Z21 + Z23 + Y22 + AA22)/4","v":63.401237654252327},{"$f":"(AA21 + AA23 + Z22 + AB22)/4","v":63.26444860419118},{"$f":"(0.5*AB21 + 0.5*AB23 + AA22)/2","v":63.219834373795692}]
[null,120,null,null,null,null,{"$f":"(0.5*G22 + 0.5*G24 + H23)/2","v":76.157615520922263},{"$f":"(H22 + H24 + G23 + I23)/4","v":76.109853358597221},{"$f":"(I22 + I24 + H23 + J23)/4","v":75.964513200439725},{"$f":"(J22 + J24 + I23 + K23)/4","v":75.715512470772381},{"$f":"(K22 + K24 + J23 + L23)/4","v":75.353093774310395},{"$f":"(L22 + L24 + K23 + M23)/4","v":74.865066008824783},{"$f":"(M22 + M24 + L23 + N23)/4","v":74.239997051478326},{"$f":"(N22 + N24 + M23 + O23)/4","v":73.473576613752073},{"$f":"(O22 + O24 + N23 + P23)/4","v":72.577587264981219},{"$f":"(P22 + P24 + O23 + Q23)/4","v":71.584457402813939},{"$f":"(Q22 + Q24 + P23 + R23)/4","v":70.533911456817975},{"$f":"(R22 + R24 + Q23 + S23)/4","v":69.464671820943849},{"$f":"(S22 + S24 + R23 + T23)/4","v":68.414140365954623},{"$f":"(T22 + T24 + S23 + U23)/4","v":67.421036445048927},{"$f":"(U22 + U24 + T23 + V23)/4","v":66.525079114974346},{"$f":"(V22 + V24 + U23 + W23)/4","v":65.758690910494835},{"$f":"(W22 + W24 + V23 + X23)/4","v":65.133650614961113},{"$f":"(X22 + X24 + W23 + Y23)/4","v":64.645646273006633},{"$f":"(Y22 + Y24 + X23 + Z23)/4","v":64.283245370626346},{"$f":"(Z22 + Z24 + Y23 + AA23)/4","v":64.034256964722303},{"$f":"(AA22 + AA24 + Z23 + AB23)/4","v":63.888923950078095},{"$f":"(0.5*AB22 + 0.5*AB24 + AA23)/2","v":63.841163974609273}]
[null,110,null,null,null,null,{"$f":"(0.5*G23 + 0.5*G25 + H24)/2","v":75.63162436376669},{"$f":"(H23 + H25 + G24 + I24)/4","v":75.582764539802739},{"$f":"(I23 + I25 + H24 + J24)/4","v":75.43496331485855},{"$f":"(J23 + J25 + I24 + K24)/4","v":75.184751975022195},{"$f":"(K23 + K25 + J24 + L24)/4","v":74.827040656921724},{"$f":"(L23 + L25 + K24 + M24)/4","v":74.356494139951053},{"$f":"(M23 + M25 + L24 + N24)/4","v":73.770025278746033},{"$f":"(N23 + N25 + M24 + O24)/4","v":73.070491934325048},{"$f":"(O23 + O25 + N24 + P24)/4","v":72.270546200382611},{"$f":"(P23 + P25 + O24 + Q24)/4","v":71.393624850209278},{"$f":"(Q23 + Q25 + P24 + R24)/4","v":70.469316985720099},{"$f":"(R23 + R25 + Q24 + S24)/4","v":69.529134495528979},{"$f":"(S23 + S25 + R24 + T24)/4","v":68.604836585254716},{"$f":"(T23 + T25 + S24 + U24)/4","v":67.727933280628974},{"$f":"(U23 + U25 + T24 + V24)/4","v":66.928010466985967},{"$f":"(V23 + V25 + U24 + W24)/4","v":66.228501354855581},{"$f":"(W23 + W25 + V24 + X24)/4","v":65.642055243030924},{"$f":"(X23 + X25 + W24 + Y24)/4","v":65.171528269003545},{"$f":"(Y23 + Y25 + X24 + Z24)/4","v":64.81383241652037},{"$f":"(Z23 + Z25 + Y24 + AA24)/4","v":64.5636321128368},{"$f":"(AA23 + AA25 + Z24 + AB24)/4","v":64.415837396941441},{"$f":"(0.5*AB23 + 0.5*AB25 + AA24)/2","v":64.36697954917652}]
[null,100,null,null,null,null,{"$f":"(0.5*G24 + 0.5*G26 + H25)/2","v":75.203373000322756},{"$f":"(H24 + H26 + G25 + I25)/4","v":75.154630763857526},{"$f":"(I24 + I26 + H25 + J25)/4","v":75.007837205395646},{"$f":"(J24 + J26 + I25 + K25)/4","v":74.761505175618055},{"$f":"(K24 + K26 + J25 + L25)/4","v":74.413836547286991},{"$f":"(L24 + L26 + K25 + M25)/4","v":73.963858541851408},{"$f":"(M24 + M26 + L25 + N25)/4","v":73.413132047592711},{"$f":"(N24 + N26 + M25 + O25)/4","v":72.767833829070128},{"$f":"(O24 + O26 + N25 + P25)/4","v":72.040495032212704},{"$f":"(P24 + P26 + O25 + Q25)/4","v":71.250193132525339},{"$f":"(Q24 + Q26 + P25 + R25)/4","v":70.420611429599631},{"$f":"(R24 + R26 + Q25 + S25)/4","v":69.577726772156325},{"$f":"(S24 + S26 + R25 + T25)/4","v":68.748152206774691},{"$f":"(T24 + T26 + S25 + U25)/4","v":67.957863412375872},{"$f":"(U24 + U26 + T25 + V25)/4","v":67.230541662350021},{"$f":"(V24 + V26 + U25 + W25)/4","v":66.585262102536163},{"$f":"(W24 + W26 + V25 + X25)/4","v":66.034553813164052},{"$f":"(X24 + X26 + W25 + Y25)/4","v":65.584592027179497},{"$f":"(Y24 + Y26 + X25 + Z25)/4","v":65.236936634276901},{"$f":"(Z24 + Z26 + Y25 + AA25)/4","v":64.990614266345361},{"$f":"(AA24 + AA26 + Z25 + AB25)/4","v":64.843826477863004},{"$f":"(0.5*AB24 + 0.5*AB26 + AA25)/2","v":64.795085968018697}]
[null,90,null,null,null,null,{"$f":"(0.5*G25 + 0.5*G27 + H26)/2","v":74.872628121572205},{"$f":"(H25 + H27 + G26 + I26)/4","v":74.824563137110999},{"$f":"(I25 + I27 + H26 + J26)/4","v":74.68026439928164},{"$f":"(J25 + J27 + I26 + K26)/4","v":74.439609842845869},{"$f":"(K25 + K27 + J26 + L26)/4","v":74.102956745042533},{"$f":"(L25 + L27 + K26 + M26)/4","v":73.671986443261019},{"$f":"(M25 + M27 + L26 + N26)/4","v":73.150825638344315},{"$f":"(N25 + N27 + M26 + O26)/4","v":72.54723147796858},{"$f":"(O25 + O27 + N26 + P26)/4","v":71.873422194663533},{"$f":"(P25 + P27 + O26 + Q26)/4","v":71.146056455620823},{"$f":"(Q25 + Q27 + P26 + R26)/4","v":70.38522402234625},{"$f":"(R25 + R27 + Q26 + S26)/4","v":69.613024052196735},{"$f":"(S25 + S27 + R26 + T26)/4","v":68.852197004120768},{"$f":"(T25 + T27 + S26 + U26)/4","v":68.124841261062784},{"$f":"(U25 + U27 + T26 + V26)/4","v":67.451045223124225},{"$f":"(V25 + V27 + U26 + W26)/4","v":66.847465925888301},{"$f":"(W25 + W27 + V26 + X26)/4","v":66.326320026229268},{"$f":"(X25 + X27 + W26 + Y26)/4","v":65.895363358376301},{"$f":"(Y25 + Y27 + X26 + Z26)/4","v":65.558721639035241},{"$f":"(Z25 + Z27 + Y26 + AA26)/4","v":65.318075528250446},{"$f":"(AA25 + AA27 + Z26 + AB26)/4","v":65.173781875931724},{"$f":"(0.5*AB25 + 0.5*AB27 + AA26)/2","v":65.125718384243655}]
[null,80,null,null,null,null,{"$f":"(0.5*G26 + 0.5*G28 + H27)/2","v":74.638036631110324},{"$f":"(H26 + H28 + G27 + I27)/4","v":74.590744970251066},{"$f":"(I26 + I28 + H27 + J27)/4","v":74.449063111306046},{"$f":"(J26 + J28 + I27 + K27)/4","v":74.213728770532441},{"$f":"(K26 + K28 + J27 + L27)/4","v":73.886409906372705},{"$f":"(L26 + L28 + K27 + M27)/4","v":73.470320660934874},{"$f":"(M26 + M28 + L27 + N27)/4","v":72.970968453906124},{"$f":"(N26 + N28 + M27 + O27)/4","v":72.396860165765133},{"$f":"(O26 + O28 + N27 + P27)/4","v":71.759921752933593},{"$f":"(P26 + P28 + O27 + Q27)/4","v":71.075402403313618},{"$f":"(Q26 + Q28 + P27 + R27)/4","v":70.361220031354847},{"$f":"(R26 + R28 + Q27 + S27)/4","v":69.636964195386781},{"$f":"(S26 + S28 + R27 + T27)/4","v":68.922786148308589},{"$f":"(T26 + T28 + S27 + U27)/4","v":68.238274892868603},{"$f":"(U26 + U28 + T27 + V27)/4","v":67.601347349445362},{"$f":"(V26 + V28 + U27 + W27)/4","v":67.027251470052093},{"$f":"(W26 + W28 + V27 + X27)/4","v":66.527911943421614},{"$f":"(X26 + X28 + W27 + Y27)/4","v":66.111834509054376},{"$f":"(Y26 + Y28 + X27 + Z27)/4","v":65.784525656526768},{"$f":"(Z26 + Z28 + Y27 + AA27)/4","v":65.549198832036723},{"$f":"(AA26 + AA28 + Z27 + AB27)/4","v":65.407521521195733},{"$f":"(0.5*AB26 + 0.5*AB28 + AA27)/2","v":65.360231168177279}]
[null,70,null,null,null,null,{"$f":"(0.5*G27 + 0.5*G29 + H28)/2","v":74.498052815949364},{"$f":"(H27 + H29 + G28 + I28)/4","v":74.451333272587732},{"$f":"(I27 + I29 + H28 + J28)/4","v":74.311530561022821},{"$f":"(J27 + J29 + I28 + K28)/4","v":74.079848485707601},{"$f":"(K27 + K29 + J28 + L28)/4","v":73.758649739097393},{"$f":"(L27 + L29 + K28 + M28)/4","v":73.351934166496221},{"$f":"(M27 + M29 + L28 + N28)/4","v":72.865883713915167},{"$f":"(N27 + N29 + M28 + O28)/4","v":72.309335369085915},{"$f":"(O27 + O29 + N28 + P28)/4","v":71.694018646421711},{"$f":"(P27 + P29 + O28 + Q28)/4","v":71.034427750667632},{"$f":"(Q27 + Q29 + P28 + R28)/4","v":70.347305826184993},{"$f":"(R27 + R29 + Q28 + S28)/4","v":69.650842780061708},{"$f":"(S27 + S29 + R28 + T28)/4","v":68.96372460679396},{"$f":"(T27 + T29 + S28 + U28)/4","v":68.30414076791736},{"$f":"(U27 + U29 + T28 + V28)/4","v":67.688833599378555},{"$f":"(V27 + V29 + U28 + W28)/4","v":67.132296274779634},{"$f":"(W27 + W29 + V28 + X28)/4","v":66.646257210469258},{"$f":"(X27 + X29 + W28 + Y28)/4","v":66.239552360354452},{"$f":"(Y27 + Y29 + X28 + Z28)/4","v":65.918362786975365},{"$f":"(Z27 + Z29 + Y28 + AA28)/4","v":65.686687644630524},{"$f":"(AA27 + AA29 + Z28 + AB28)/4","v":65.546889138412013},{"$f":"(0.5*AB27 + 0.5*AB29 + AA28)/2","v":65.500170784728056}]
[null,60,null,null,null,null,{"$f":"(0.5*G28 + 0.5*H29)","v":74.451532893919435},{"$f":"(H28 + 0.5*G29 + 0.5*I29)/2","v":74.405021259783553},{"$f":"(I28 + 0.5*H29 + 0.5*J29)/2","v":74.265893871579607},{"$f":"(J28 + 0.5*I29 + 0.5*K29)/2","v":74.035501371643562},{"$f":"(K28 + 0.5*J29 + 0.5*L29)/2","v":73.716422915922308},{"$f":"(L28 + 0.5*K29 + 0.5*M29)/2","v":73.312899097707259},{"$f":"(M28 + 0.5*L29 + 0.5*N29)/2","v":72.83131343960315},{"$f":"(N28 + 0.5*M29 + 0.5*O29)/2","v":72.280595542182724},{"$f":"(O28 + 0.5*N29 + 0.5*P29)/2","v":71.67240630500747},{"$f":"(P28 + 0.5*O29 + 0.5*Q29)/2","v":71.021000692685533},{"$f":"(Q28 + 0.5*P29 + 0.5*R29)/2","v":70.342749251396626},{"$f":"(R28 + 0.5*Q29 + 0.5*S29)/2","v":69.655392910891194},{"$f":"(S28 + 0.5*R29 + 0.5*T29)/2","v":68.977145030027572},{"$f":"(T28 + 0.5*S29 + 0.5*U29)/2","v":68.325746127517448},{"$f":"(U28 + 0.5*T29 + 0.5*V29)/2","v":67.717565999751031},{"$f":"(V28 + 0.5*U29 + 0.5*W29)/2","v":67.166858646038065},{"$f":"(W28 + 0.5*V29 + 0.5*X29)/2","v":66.685283924630809},{"$f":"(X28 + 0.5*W29 + 0.5*Y29)/2","v":66.281770440857869},{"$f":"(Y28 + 0.5*X29 + 0.5*Z29)/2","v":65.962700853649153},{"$f":"(Z28 + 0.5*Y29 + 0.5*AA29)/2","v":65.732315071164507},{"$f":"(AA28 + 0.5*Z29 + 0.5*AB29)/2","v":65.593191760474866},{"$f":"(0.5*AB28 + 0.5*AA29)","v":65.546681272601461}]
[null,50]
[null,40]
[null,30]
[null,20]
[null,10]
[null,0]
[null,null,0,{"$f":"C36+cellsize","v":10},20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290]
[null,null,"X"]

{"sheet":"Gradient","index":1,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,0,34,0],[36,2,36,31]]}
["Hydraulic Gradient"]
[null,null,null,null,null,null,null,null,null,null,"Critical gradient:",0.2,{"$f":"\"[\" & lunit & \"/\" & tunit & \"]\"","v":"[ft/day]"}]
[]
[]
[]
[null,null,null,"Max gradient:",{"$f":"MAX(C10:AF35)","v":0.3503428067765692},{"$f":"\"[\" & lunit & \"/\" & tunit & \"]\"","v":"[ft/day]"}]
[]
[]
[]
["Y",{"$f":"B11+cellsize","v":250}]
[null,240]
[null,230]
[null,220]
[null,210]
[null,200]
[null,190]
[null,180]
[null,170,null,null,null,null,8.7671372501327477E-2,8.9229362696789855E-2,9.4136090035709691E-2,0.10319871163352445,0.11822707773896468,0.14322521239991773,0.18784360865351743,0.34843493752780613,0.3503428067765692,0.24096303134176578,0.20920041630362476,0.20919461619471319,0.24094315490811813,0.35029666686679495,0.34837650977059592,0.18780292709172669,0.14318891034257747,0.1181930247433776,0.10316591814749643,9.4104016928533693E-2,8.9197664688566644E-2,8.7639787394981281E-2]
[null,160,null,null,null,null,8.612718339629985E-2,8.7614421606638695E-2,9.2322514617428839E-2,0.10093692674190136,0.11499683253067462,0.13788086313082074,0.17819370647846619,0.26433086418104595,0.22944903348311557,0.20651150226970777,0.19401818234839957,0.19401335222752542,0.20649640387158408,0.22942200536851792,0.26428653257810442,0.17815635795086621,0.13784639101222113,0.11496392237886442,0.10090494636588181,9.229108610676981E-2,8.7583285251703197E-2,8.6096137622200752E-2]
[null,150,null,null,null,null,8.1721821009426335E-2,8.3031460806205618E-2,8.7248360635779482E-2,9.4761695103351598E-2,0.10642089675757276,0.12361324610815666,0.14793271091024934,0.1769715276392537,0.17643004167576878,0.17213619649616826,0.16874746740965921,0.1687435248069141,0.17212420462150885,0.17640957022932904,0.17694226084880549,0.1479022805063285,0.12358288662364102,0.10639078952843985,9.4731813095138506E-2,8.7218633817714816E-2,8.300181868103515E-2,8.1692212559860825E-2]
[null,140,null,null,null,null,7.5032504978788023E-2,7.6132208999364195E-2,7.9790319589850833E-2,8.6091013700900554E-2,9.5305639681864632E-2,0.10761546370783956,0.12244703308071839,0.13662167817761123,0.14213525688007492,0.14373339950717892,0.14389644416997863,0.14389325961044927,0.14372383285712426,0.14211936220368809,0.13660008952005592,0.12242262448571972,0.10758966302037709,9.5279082831596543E-2,8.6064001177193289E-2,7.9763017194043259E-2,7.6104735947096977E-2,7.5004993721800806E-2]
[null,130,null,null,null,null,6.6766702925836544E-2,6.7689635974960916E-2,7.0907903175378789E-2,7.6265328737564725E-2,8.3691908363104847E-2,9.2898323445332401E-2,0.10304249816618717,0.11230133274287679,0.11826637953380163,0.12153371679415488,0.12291578521221391,0.12291326423444074,0.12152619894074583,0.11825406527666003,0.11228481637894271,0.10302306755756913,9.2876952956201408E-2,8.366920112457249E-2,7.6241663682759933E-2,7.0883560536818616E-2,6.7664874760408986E-2,6.6741831841068716E-2]
[null,120,null,null,null,null,5.7576180737485341E-2,5.8393638984294331E-2,6.1392482651420152E-2,6.6227175957386614E-2,7.2635638823800225E-2,8.0175259036779065E-2,8.8112696892914899E-2,9.5384723491401702E-2,0.10092911898680566,0.10451606175891352,0.1062470113085604,0.10624507512287071,0.10451030809761351,0.1009197401786727,9.5372124262865551E-2,8.8097518523737678E-2,8.0158079041641711E-2,7.2616881608233069E-2,6.6207157354274765E-2,6.1371492796067441E-2,5.837201370061091E-2,5.7554380669035295E-2]
[null,110,null,null,null,null,4.7962916821552418E-2,4.8764080076080782E-2,5.1809543156200476E-2,5.6562989362494466E-2,6.2615173354723802E-2,6.945329552695885E-2,7.6445274289535126E-2,8.286357597463738E-2,8.803948508320221E-2,9.159934809822573E-2,9.3396525191088667E-2,9.3395097148761652E-2,9.1595109108232431E-2,8.8032576170624086E-2,8.2854242857005725E-2,7.6433842918614742E-2,6.9440068076188924E-2,6.2600379794178901E-2,5.6546813349199851E-2,5.1792201724127823E-2,4.8745919155615096E-2,4.7944521954527419E-2]
[null,100,null,null,null,null,3.826256380363869E-2,3.9151448372557143E-2,4.2548466461955356E-2,4.7647248944082336E-2,5.3864828288692462E-2,6.0621560952763512E-2,6.734074142711173E-2,7.3449927254018485E-2,7.8437198814020198E-2,8.193476534436106E-2,8.372896815776136E-2,8.3727969610228728E-2,8.193180278272516E-2,7.8432368007339631E-2,7.3443373589517011E-2,6.7332629132223348E-2,6.0612022836291371E-2,5.3853936390342652E-2,4.763503271197532E-2,4.2535000067711479E-2,3.9137006491022773E-2,3.8247828332893016E-2]
[null,90,null,null,null,null,2.8673299519856942E-2,2.9790427842845565E-2,3.3927652019043034E-2,3.9791951919855906E-2,4.6568257335650474E-2,5.3622504421318495E-2,6.0427579682129258E-2,6.6509270820867841E-2,7.144965946813378E-2,7.492145567244371E-2,7.6709105144891612E-2,7.6708452105636607E-2,7.4919522195246821E-2,7.1446516533108628E-2,6.650501689397631E-2,6.0422311297324054E-2,5.3616278985346481E-2,4.6561061314866412E-2,3.9783692604983434E-2,3.3918217525354205E-2,2.9779903786723225E-2,2.8662412025889809E-2]
[null,80,null,null,null,null,1.9317079371986425E-2,2.0917607467452855E-2,2.6368199977971556E-2,3.3392135939411483E-2,4.0963705908444947E-2,4.8489008452703146E-2,5.5531880056750617E-2,6.1709684573987358E-2,6.6679077897897399E-2,7.0157473793390671E-2,7.1946860106067032E-2,7.1946460181922647E-2,7.0156297289476643E-2,6.667718899296407E-2,6.1707172279238297E-2,5.5528833831883138E-2,4.8485488193648764E-2,4.095970795039431E-2,3.3387554402401223E-2,2.6362799633747228E-2,2.0911153048313241E-2,1.931017662264381E-2]
[null,70,null,null,null,null,1.0430234083289793E-2,1.3161035034338894E-2,2.070949135852948E-2,2.9044953974608542E-2,3.7375014950194886E-2,4.5327001991620451E-2,5.259557688474549E-2,5.8880957471488311E-2,6.3895404407415396E-2,6.7390544586177742E-2,6.9185366899212813E-2,6.9185118469573356E-2,6.7389822800918153E-2,6.3894275165088943E-2,5.8879516363478747E-2,5.2593931325240456E-2,4.5325251377353611E-2,3.7373229736027115E-2,2.9043148035693085E-2,2.0707565421155347E-2,1.315864107698397E-2,1.042740992962417E-2]
[null,60,null,null,null,null,6.5783415298757445E-3,1.0373167238788693E-2,1.9031275732491831E-2,2.7829178254195192E-2,3.6376060438594808E-2,4.4427319941936091E-2,5.173084465057496E-2,5.801660189895598E-2,6.301681483871488E-2,6.6496388006209703E-2,6.8281860728871865E-2,6.8281650641107222E-2,6.6495780953735664E-2,6.3015876332311288E-2,5.8015428549417956E-2,5.1729548929632573E-2,4.4426014523495219E-2,3.6374844564092353E-2,2.7828125589107727E-2,1.9030415964057502E-2,1.0372414821939395E-2,6.5774793755086595E-3]
[null,50]
[null,40]
[null,30]
[null,20]
[null,10]
[null,0]
[null,null,0,{"$f":"C36+cellsize","v":10},20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290]
[null,null,"X"]

{"sheet":"Flow Rate","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Flow Rate"]
[]
[null,null,"K:",0.5,{"$f":"\"[\" & lunit & \"/\" & tunit & \"]\"","v":"[ft/day]"}]
[null,null,"Problem length (transverse):",200,{"$f":"\"[\" & lunit & \"]\"","v":"[ft]"}]
[null,null,"Head boundary:",2,"<-- Select 1 or 2"]
[]
[]
[null,"xi:",180,190,200,210,220,230,240,250]
[null,"Ai:",{"$f":"cellsize/2","v":5},{"$f":"cellsize","v":10},{"$f":"cellsize","v":10},{"$f":"cellsize","v":10},{"$f":"cellsize","v":10},{"$f":"cellsize","v":10},{"$f":"cellsize","v":10},{"$f":"cellsize/2","v":5}]
[null,"dh/dy:",{"$f":"(Main!$U$18 - Main!$U$19)/cellsize","v":-0.2783382899625863},{"$f":"(Main!$V$18 - Main!$V$19)/cellsize","v":-0.18780540851055746},{"$f":"(Main!$W$18 - Main!$W$19)/cellsize","v":-0.14319111462276127},{"$f":"(Main!$X$18 - Main!$X$19)/cellsize","v":-0.1181950830754758},{"$f":"(Main!$Y$18 - Main!$Y$19)/cellsize","v":-0.10316789131403041},{"$f":"(Main!$Z$18 - Main!$Z$19)/cellsize","v":-9.4105937916688726E-2},{"$f":"(Main!$AA$18 - Main!$AA$19)/cellsize","v":-8.9199554483101906E-2},{"$f":"(Main!$AB$18 - Main!$AB$19)/cellsize","v":-8.7641661765272258E-2}]
[null,"vi:",{"$f":"k*C10","v":-0.13916914498129315},{"$f":"k*D10","v":-9.3902704255278732E-2},{"$f":"k*E10","v":-7.1595557311380634E-2},{"$f":"k*F10","v":-5.9097541537737899E-2},{"$f":"k*G10","v":-5.1583945657015205E-2},{"$f":"k*H10","v":-4.7052968958344363E-2},{"$f":"k*I10","v":-4.4599777241550953E-2},{"$f":"k*J10","v":-4.3820830882636129E-2}]
[null,"qi:",{"$f":"C9*C11","v":-0.69584572490646579},{"$f":"D9*D11","v":-0.93902704255278735},{"$f":"E9*E11","v":-0.71595557311380631},{"$f":"F9*F11","v":-0.59097541537737897},{"$f":"G9*G11","v":-0.51583945657015207},{"$f":"H9*H11","v":-0.47052968958344366},{"$f":"I9*I11","v":-0.44599777241550953},{"$f":"J9*J11","v":-0.21910415441318065}]
[]
[null,"Unit Q:",{"$f":"SUM(C12:J12)","v":-4.5932748289327243},{"$f":"\"[\"&lunit&\"^3/\"&tunit&\"/\"&lunit&\"]\"","v":"[ft^3/day/ft]"}]
[null,"Total Q:",{"$f":"unitq*length","v":-918.65496578654484},{"$f":"\"[\"&lunit&\"^3/\"&tunit&\"]\"","v":"[ft^3/day]"}]